forum

Home / DeveloperSection / Forums / How to use self join in sql server and what's it's important.

How to use self join in sql server and what's it's important.

Anonymous User183716-May-2013

Hi All!

How to use self join in sql server and what's it's important.

Please give any example.

Thanks in advance!

Updated on 16-May-2013

I am a content writter !

Can you answer this question?

Answer

16-May-2013

Self Join

Self join correlates rows of a table with the other rows of the same table. It is used when a table has to be joined to itself to produce results.

Example

First you have to create a table EmpTable and enter the details like this:

EmpIDEmpNameEmpMgrID

1Smith2

2Sai3

3Suresh1

4Bill2

5Steve4

SELECT E2.EMPNAME,E1.EMPNAME as 'MANAGER'
FROM EmpTable E1
INNER JOIN EmpTable E2
ON E1.EMPID=E2.EMPMGRID

Output

EmpNameManager

SureshSmith

SmithSai

BillSai

SaiSuresh

SteveBill